Skip Headers

Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-02 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# V$BUFFERED_QUEUES

`V$BUFFERED_QUEUES` displays information about all buffered queues in the instance. There is one row per queue.

Column | Datatype | Description
--- | --- | ---
`QUEUE_ID` | `NUMBER` | Identifier for the queue
`QUEUE_SCHEMA` | `VARCHAR2(30)` | Owner of the queue
`QUEUE_NAME` | `VARCHAR2(30)` | Name of the queue
`STARTUP_TIME` | `DATE` | Startup time
`NUM_MSGS` | `NUMBER` | Total number of messages currently in the buffered queue
`SPILL_MSGS` | `NUMBER` | Current number of overflow messages spilled to disk from the buffered queue
`CNUM_MSGS` | `NUMBER` | Cumulative total number of messages enqueued into the buffered queue since the database last started
`CSPILL_MSGS` | `NUMBER` | Cumulative total number of overflow messages spilled to disk from the buffered queue since the database last started